//Upgrading from 1.2 > 1.6.
replace all files.
Go to Administration VArcade admin > settings > hit the upgrade button (bottom of page)

If you have problems with that run, 
We will run this in a costumepage preview instead, 
(Give a temp title & then paste code with <?php ?> tags & hit preview once!)
We can just run everything, previusly added aswell it will cover whats missing and 
it will let you know it cant create some tables because they exist if they do and thats just normal and all good.

<?php
$upgrade = dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD cost int(10) NOT NULL default '0' AFTER hiscoredate");
$upgrade= dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD reward int(10) NOT NULL default '0' AFTER cost");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD bonus int(10) NOT NULL default '0' AFTER reward");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."varcade_settings ADD usergold CHAR(1) NOT NULL default '0' AFTER touringp");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."varcade_settings ADD bannerimg VARCHAR(50) NOT NULL default '0' AFTER related");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."varcade_settings ADD playingnow CHAR(1) NOT NULL default '0' AFTER bannerimg");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."varcade_settings ADD keepalive CHAR(1) NOT NULL default '0' AFTER usergold");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."varcade_settings ADD ingameopts CHAR(1) NOT NULL default '0' AFTER keepalive");
$upgrade = dbquery("ALTER TABLE ".$db_prefix."varcade_settings ADD related CHAR(1) NOT NULL default '0' AFTER ingameopts");
$upgrade = dbquery("UPDATE ".$db_prefix."admin SET admin_image='arcade.gif' WHERE admin_title ='VArcade'");
$upgrade = dbquery("UPDATE ".$db_prefix."varcade_settings SET version='1.6'");
$upgrade = dbquery("UPDATE ".$db_prefix."infusions SET inf_version='1.6' WHERE inf_title='VArcade'");

//Fix the reverse scoreing issues in the database, since highest have been saved 
//not really a must do, it will sort by it self when games are beeing played now,
//just that the current hi-score holders dont really earned their hi-scores,
//they actually sucked most in these games.
$result = dbquery("UPDATE ".$db_prefix."varcade_games SET hi_player='0' WHERE reverse='1'");
$result = dbquery("UPDATE ".$db_prefix."varcade_games SET hiscore='0' WHERE reverse='1'"); //dosent really do any differance but for the sake of it we reset this one!


$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_active (
 `game_id` int(10) NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `icon` varchar(50) NOT NULL default '',
  `lastactive` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM; ");

$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_activeusr (
 `game_id` int(10) NOT NULL default '0',
  `player` int(10) NOT NULL default '0',
  `user_ip` varchar(20) NOT NULL default '0',
  `lastactive` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM; ");
?>


//Upgrading from 1.0 > 1.2.
replace all files.
rename game folder to uploads.
go to Administration VArcade admin > settings > hit the upgrade button (bottom of page)


This is to upgrade from old Ausimods Arcade.
upload all files in this pack to varcade.
copy or move your games from arcade/uploads to varcade/uploads, 
category images goes to varcade/categoryimg

VERRY Importante if you have a private grp!
Check your adult group number and replace the access='6' to your number,
Example: Administration > user admin > User Groups "[6] Private" 
(the number at the side of the name is what you want)
If you dont have any private groups set, just run the query anyway. 
Change the line dbquery("UPDATE ".$db_prefix."varcade_games SET access='6' WHERE status='2'"); //Lets set all games that private to your "adult grp" to your numbers if needed before running this.
You will haveto change group access level manualy,its verry easy from the admin section.

Now paste this code in a costumepage in adminstration, give a temp title & then run a preview once and youre done,
Due to varius mods you might and might not have, there might be some error messages, this is perfectly normal, it only reports they are not found if they arnt there and moves along.

note:
//If you have gold system active
After upgradeing or if you wanto use it you need to run this to re-set cost & payments for games, number is what you want it to cost and pay.

$upgrade = dbquery("UPDATE ".$db_prefix."varcade_games SET cost='5'");
$upgrade = dbquery("UPDATE ".$db_prefix."varcade_games SET reward='5'");
$upgrade = dbquery("UPDATE ".$db_prefix."varcade_games SET bonus='10'");


//Upgradeing from old Arcade (Any version, with any known mods)

<?php
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_games DROP play_cost");
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_games DROP downloads");
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_games DROP download_value");
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_games DROP reward");
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_games DROP bonus");

//Assuming you have the altime_player mod (we will have no support for it, so it will be dropped)
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_games DROP altime_player");
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_games DROP altime_score");

//ok everything we dont want is dropped, lets move the table!
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_games RENAME ".$db_prefix."varcade_games");

//Lets start tracking when people get their hi-scores
$result = dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD hiscoredate int(1) NOT NULL AFTER reverse"); 

//ADD some user gold support stuff in correct sequense (you will haveto re-set these values for games).
$result = dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD cost int(10) NOT NULL default '0' AFTER hiscoredate");
$result = dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD reward int(10) NOT NULL default '0' AFTER cost");
$result = dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD bonus int(10) NOT NULL default '0' AFTER reward");

//Lets implement new access system table
$result = dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD access int(1) NOT NULL AFTER hiscoredate"); 

//the error report system wanto come too!
$result = dbquery("ALTER TABLE ".$db_prefix."varcade_games ADD errorreport char(1) NOT NULL AFTER access"); 

//lets hackup some values we might be missing & fix the access system
$result = dbquery("UPDATE ".$db_prefix."varcade_games SET access='0' WHERE status='2'"); //Lets set all games that private to your "adult grp"
$result = dbquery("UPDATE ".$db_prefix."varcade_games SET status='2' WHERE status='1'"); // Ok now let give all available games status 2 wich is active in VArcade.
$result = dbquery("UPDATE ".$db_prefix."varcade_games SET hi_player='0' WHERE hi_player=''"); // Lets give hi_player a fixed value we can use if there is no players.
$result = dbquery("UPDATE ".$db_prefix."varcade_games SET hiscore='0' WHERE hiscore=''"); // Lets give hiscore a fixed value we can use if none is set.
$result = dbquery("UPDATE ".$db_prefix."varcade_games SET hiscoredate='0' WHERE hiscoredate=''"); // Lets give hiscoredate a fixed value we can use if none is set.


//the status is not needed when you can set admin only for cat accesss , 
//we will only have 1 level of categorys available so parent will go too.
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_cats DROP status");
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_cats DROP parentid");

//Lets move the table
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_cats RENAME ".$db_prefix."varcade_cats");

//Add the access system
$result = dbquery("ALTER TABLE ".$db_prefix."varcade_cats ADD access int(1) NOT NULL AFTER image"); 


//we can just keep score as it is, lets move it!
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_score RENAME ".$db_prefix."varcade_score");


//Delete old arcade settings table 
$result = dbquery("DROP TABLE ".$db_prefix."inf_settings");

//If you have the favourites mod, we need to move it.
$result = dbquery("ALTER TABLE ".$db_prefix."favourites RENAME ".$db_prefix."varcade_favourites");
$result = dbquery("ALTER TABLE ".$db_prefix."arcade_favourites RENAME ".$db_prefix."varcade_favourites");

//lets change the infusion title.
$result = dbquery("UPDATE ".$db_prefix."infusions SET inf_title='varcade' WHERE inf_folder='Arcade'");

//lets set version
$result = dbquery("UPDATE ".$db_prefix."infusions SET inf_version='1.0' WHERE inf_folder='Arcade'");

//lets change the infusion folder.
$result = dbquery("UPDATE ".$db_prefix."infusions SET inf_folder='varcade' WHERE inf_folder='Arcade'");

//lets change the old admin title
$result = dbquery("UPDATE ".$db_prefix."admin SET admin_title='VArcade' WHERE admin_link='../infusions/arcade/admin/index.php'");

//now change the link
$result = dbquery("UPDATE ".$db_prefix."admin SET admin_link='../infusions/varcade/admin/admin.php' WHERE admin_link='../infusions/arcade/admin/index.php'");

//Finaly create tables needed for the new arcade to function.

$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_settings (
`id` smallint(5) unsigned NOT NULL auto_increment,
  `thumbs_per_row` char(1) NOT NULL default '0',
  `thumbs_per_page` char(1) NOT NULL default '0',
  `allow_guest_play` char(1) NOT NULL default '0',
  `showsize` char(1) NOT NULL default '',
  `favorites` char(1) NOT NULL default '',
  `recommend` char(1) NOT NULL default '',
  `ratings` char(1) NOT NULL default '',
  `sound` char(1) NOT NULL default '',
  `comments` char(1) NOT NULL default '',
  `reports` char(1) NOT NULL default '',
  `hiscorepm` char(1) NOT NULL default '',
  `flashdetection` char(1) NOT NULL default '',
  `tournaments` char(1) NOT NULL default '',
  `touringp` char(1) NOT NULL default '',
  `ingameopts` char(1) NOT NULL default '',
  `related` char(1) NOT NULL default '',
  `bannerimg` varchar(50) NOT NULL default '',
  `playingnow` char(1) NOT NULL default '',
  `usergold` char(1) NOT NULL default '',
  `keepalive` char(1) NOT NULL default '',
  `popup` char(1) NOT NULL default '0',
  `version` varchar(5) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM; ");

$result = dbquery("INSERT INTO ".$db_prefix."varcade_settings(id ,thumbs_per_row,thumbs_per_page ,allow_guest_play ,showsize,favorites,recommend,ratings,sound,comments,reports,hiscorepm,flashdetection,tournaments,touringp,ingameopts,related,bannerimg,playingnow,usergold,keepalive,popup,version) VALUES (1, '2', '6', '1', '1', '1', '1', '1', '1', '1', '1', '1','1','1','1','1', '1', '1', '1','0','1','1','1.0')");

$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_ratings (
 `rating_id` mediumint(10) unsigned NOT NULL auto_increment,
  `rating_item_id` mediumint(10) unsigned NOT NULL default '0',
  `rating_type` char(1) NOT NULL default '',
  `rating_user` mediumint(10) unsigned NOT NULL default '0',
  `rating_vote` tinyint(1) unsigned NOT NULL default '0',
  `rating_datestamp` int(10) unsigned NOT NULL default '0',
  `rating_ip` varchar(20) NOT NULL default '0.0.0.0',
  PRIMARY KEY  (`rating_id`)
) TYPE=MyISAM; ");


//lets try yo create favorites even if they existed just to be safe.
$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_favourites (
  `fav_id` mediumint(10) NOT NULL default '0',
  `fav_user` mediumint(10) NOT NULL default '0',
  `fav_date` varchar(20) NOT NULL default '',
  `fav_icon` varchar(30) NOT NULL default '',
  `fav_gamename` varchar(30) NOT NULL default ''
) TYPE=MyISAM; ");


$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_tournament_scores (
  `id` mediumint(10) NOT NULL auto_increment,
  `game_id` mediumint(10) NOT NULL default '0',
  `player_id` mediumint(10) NOT NULL default '0',
  `tour_id` mediumint(10) NOT NULL default '0',
  `game_score` mediumint(20) NOT NULL default '0',
  `score_date` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM; ");

$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_tournaments (
  `id` mediumint(10) NOT NULL auto_increment,
  `tour_game` int(10) NOT NULL default '0',
  `tour_title` varchar(100) NOT NULL default '0',
  `tour_icon` varchar(100) NOT NULL default '',
  `tour_flash` varchar(100) NOT NULL default '',
  `tour_winner` varchar(100) NOT NULL default '0',
  `tour_score` int(20) NOT NULL default '0',
  `tour_players` smallint(10) NOT NULL default '0',
  `tour_reverse` char(1) NOT NULL default '',
  `tour_startdate` int(10) unsigned default NULL,
  `tour_enddate` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM; ");


$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_active (
 `game_id` int(10) NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `icon` varchar(50) NOT NULL default '',
  `lastactive` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM; ");

$result = dbquery("CREATE TABLE ".DB_PREFIX."varcade_activeusr (
 `game_id` int(10) NOT NULL default '0',
  `player` int(10) NOT NULL default '0',
  `user_ip` varchar(20) NOT NULL default '0',
  `lastactive` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM; ");

//Upgrade complete, have fun!

?>
